﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCanhBao" targetNamespace="http://tempuri.org/dsCanhBao.xsd" xmlns:mstns="http://tempuri.org/dsCanhBao.xsd" xmlns="http://tempuri.org/dsCanhBao.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="viewCanhBaoTableAdapter" GeneratorDataComponentClassName="viewCanhBaoTableAdapter" Name="viewCanhBao" UserDataComponentName="viewCanhBaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.viewCanhBao" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        viewCanhBao.*
FROM            viewCanhBao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TenCanhBao" DataSetColumn="TenCanhBao" />
              <Mapping SourceColumn="sort" DataSetColumn="sort" />
              <Mapping SourceColumn="OnBoardNumber" DataSetColumn="OnBoardNumber" />
              <Mapping SourceColumn="OnVactionNumber" DataSetColumn="OnVactionNumber" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tadSinhNhat" GeneratorDataComponentClassName="tadSinhNhat" Name="viewSinhNhat" UserDataComponentName="tadSinhNhat">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblPhong.cTenPhong, tblNhanSu.cTenNhanSu, tblNhanSu.pAnhDaiDien, tblNhanSu.cSoDienThoai, tblNhanSu.dNgaySinh
FROM            tblNhanSu INNER JOIN
                         tblPhong ON tblNhanSu.iPhongID = tblPhong.iPhongId
WHERE        (MONTH(tblNhanSu.dNgaySinh) = MONTH(GETDATE())) AND (DAY(tblNhanSu.dNgaySinh) = DAY(GETDATE()) OR
                         DAY(tblNhanSu.dNgaySinh) = DAY(GETDATE()) + 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cTenPhong" DataSetColumn="cTenPhong" />
              <Mapping SourceColumn="cTenNhanSu" DataSetColumn="cTenNhanSu" />
              <Mapping SourceColumn="pAnhDaiDien" DataSetColumn="pAnhDaiDien" />
              <Mapping SourceColumn="cSoDienThoai" DataSetColumn="cSoDienThoai" />
              <Mapping SourceColumn="dNgaySinh" DataSetColumn="dNgaySinh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnBoardVisaTableAdapter" GeneratorDataComponentClassName="OnBoardVisaTableAdapter" Name="OnBoardVisa" UserDataComponentName="OnBoardVisaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        c.nRankID, c.cFamilyName, c.cMiddleName, c.cFirstName, a.cStatus, e.nImmigrationId, e.dDateOfExpiry, tblImmigrationDoc.cDocName, DATEDIFF(DD, GETDATE(), 
                         e.dDateOfExpiry) AS dayLeft, DATEDIFF(mm, GETDATE(), e.dDateOfExpiry) AS monthLeft, tblVessel.cVesselName
FROM            tblCrew AS c INNER JOIN
                         tblImmigrationCrew AS e ON c.nCrewId = e.nCrewId INNER JOIN
                         tblAssignment AS a ON c.nCrewId = a.nCrewid INNER JOIN
                         tblImmigrationDoc ON e.nImmigrationId = tblImmigrationDoc.nImmigrationId INNER JOIN
                         tblVessel ON a.nVesselId = tblVessel.nVesselId
WHERE        (a.isActive = 1) AND (a.cStatus = 'On Board')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="nImmigrationId" DataSetColumn="nImmigrationId" />
              <Mapping SourceColumn="dDateOfExpiry" DataSetColumn="dDateOfExpiry" />
              <Mapping SourceColumn="cDocName" DataSetColumn="cDocName" />
              <Mapping SourceColumn="dayLeft" DataSetColumn="dayLeft" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnvacationVisaTableAdapter" GeneratorDataComponentClassName="OnvacationVisaTableAdapter" Name="OnvacationVisa" UserDataComponentName="OnvacationVisaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        c.nRankID, c.cFamilyName, c.cMiddleName, c.cFirstName, a.cStatus, e.nImmigrationId, e.dDateOfExpiry, tblImmigrationDoc.cDocName,DATEDIFF(DD, GETDATE(), 
                         e.dDateOfExpiry) AS dayLeft,DATEDIFF(mm, GETDATE(), e.dDateOfExpiry)  as monthLeft
FROM            tblCrew AS c INNER JOIN
                         tblImmigrationCrew AS e ON c.nCrewId = e.nCrewId INNER JOIN
                         tblAssignment AS a ON c.nCrewId = a.nCrewid INNER JOIN
                         tblImmigrationDoc ON e.nImmigrationId = tblImmigrationDoc.nImmigrationId
WHERE         (a.isActive = 1) AND (a.cStatus = 'On Vacation' OR
                         a.cStatus = 'New Crew')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="nImmigrationId" DataSetColumn="nImmigrationId" />
              <Mapping SourceColumn="dDateOfExpiry" DataSetColumn="dDateOfExpiry" />
              <Mapping SourceColumn="cDocName" DataSetColumn="cDocName" />
              <Mapping SourceColumn="dayLeft" DataSetColumn="dayLeft" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnBoardCertificateTableAdapter" GeneratorDataComponentClassName="OnBoardCertificateTableAdapter" Name="OnBoardCertificate" UserDataComponentName="OnBoardCertificateTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        c.nRankID, c.cFamilyName, c.cMiddleName, c.cFirstName, a.cStatus, e.nCertificationId, e.dDateOfExpire, tblCertification.cCertificationName, DATEDIFF(DD, 
                         GETDATE(), e.dDateOfExpire) AS dayLeft, DATEDIFF(mm, GETDATE(), e.dDateOfExpire) AS monthLeft, tblVessel.cVesselName
FROM            tblCrew AS c INNER JOIN
                         tblCertificateCrew AS e ON c.nCrewId = e.nCrewid INNER JOIN
                         tblAssignment AS a ON c.nCrewId = a.nCrewid INNER JOIN
                         tblCertification ON e.nCertificationId = tblCertification.nCertificationId INNER JOIN
                         tblVessel ON a.nVesselId = tblVessel.nVesselId
WHERE        (a.isActive = 1) AND (a.cStatus = 'On Board')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="nCertificationId" DataSetColumn="nCertificationId" />
              <Mapping SourceColumn="dDateOfExpire" DataSetColumn="dDateOfExpire" />
              <Mapping SourceColumn="cCertificationName" DataSetColumn="cCertificationName" />
              <Mapping SourceColumn="dayLeft" DataSetColumn="dayLeft" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TadOnVacationCertificate" GeneratorDataComponentClassName="TadOnVacationCertificate" Name="OnVacationCertificate" UserDataComponentName="TadOnVacationCertificate">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        c.nRankID, c.cFamilyName, c.cMiddleName, c.cFirstName, a.cStatus, e.nCertificationId, e.dDateOfExpire, tblCertification.cCertificationName, DATEDIFF(DD, 
                         GETDATE(), e.dDateOfExpire) AS dayLeft,DATEDIFF(mm, GETDATE(), e.dDateOfExpire) as monthLeft
FROM            tblCrew AS c INNER JOIN
                         tblCertificateCrew AS e ON c.nCrewId = e.nCrewid INNER JOIN
                         tblAssignment AS a ON c.nCrewId = a.nCrewid INNER JOIN
                         tblCertification ON e.nCertificationId = tblCertification.nCertificationId
WHERE        (a.isActive = 1) AND (a.cStatus = 'On Vacation' OR
                         a.cStatus = 'New Crew')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="nCertificationId" DataSetColumn="nCertificationId" />
              <Mapping SourceColumn="dDateOfExpire" DataSetColumn="dDateOfExpire" />
              <Mapping SourceColumn="cCertificationName" DataSetColumn="cCertificationName" />
              <Mapping SourceColumn="dayLeft" DataSetColumn="dayLeft" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnBoardContractTableAdapter" GeneratorDataComponentClassName="OnBoardContractTableAdapter" Name="OnBoardContract" UserDataComponentName="OnBoardContractTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblRank.cRankName, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cHomeNo, tblCrew.cHandNo, tblHDLD.[Ngày hết hạn], 
                         tblHDLD.[Thời hạn], tblHDLD.[Ngày ký], tblHDLD.[Số HĐLĐ], tblLoaiHD.[Tên loại hợp đồng], tblAssignment.cStatus, tblAssignment.isActive, DATEDIFF(mm, GETDATE(), 
                         tblHDLD.[Ngày hết hạn]) AS monthLeft
FROM            tblHDLD INNER JOIN
                         tblCrew ON tblHDLD.CrewID = tblCrew.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId INNER JOIN
                         tblLoaiHD ON tblHDLD.LoaiHDLD = tblLoaiHD.id INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board') </CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="Ngày hết hạn" DataSetColumn="Ngày hết hạn" />
              <Mapping SourceColumn="Thời hạn" DataSetColumn="Thời hạn" />
              <Mapping SourceColumn="Ngày ký" DataSetColumn="Ngày ký" />
              <Mapping SourceColumn="Số HĐLĐ" DataSetColumn="Số HĐLĐ" />
              <Mapping SourceColumn="Tên loại hợp đồng" DataSetColumn="Tên loại hợp đồng" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnVacationContractTableAdapter" GeneratorDataComponentClassName="OnVacationContractTableAdapter" Name="OnVacationContract" UserDataComponentName="OnVacationContractTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblRank.cRankName, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cHomeNo, tblCrew.cHandNo, tblHDLD.[Ngày hết hạn], 
                         tblHDLD.[Thời hạn], tblHDLD.[Ngày ký], tblHDLD.[Số HĐLĐ], tblLoaiHD.[Tên loại hợp đồng], tblAssignment.cStatus, tblAssignment.isActive, DATEDIFF(mm, GETDATE(), 
                         tblHDLD.[Ngày hết hạn]) AS monthLeft
FROM            tblHDLD INNER JOIN
                         tblCrew ON tblHDLD.CrewID = tblCrew.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId INNER JOIN
                         tblLoaiHD ON tblHDLD.LoaiHDLD = tblLoaiHD.id INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="Ngày hết hạn" DataSetColumn="Ngày hết hạn" />
              <Mapping SourceColumn="Thời hạn" DataSetColumn="Thời hạn" />
              <Mapping SourceColumn="Ngày ký" DataSetColumn="Ngày ký" />
              <Mapping SourceColumn="Số HĐLĐ" DataSetColumn="Số HĐLĐ" />
              <Mapping SourceColumn="Tên loại hợp đồng" DataSetColumn="Tên loại hợp đồng" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="monthLeft" DataSetColumn="monthLeft" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCanhBao" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsCanhBao" msprop:Generator_UserDSName="dsCanhBao">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="viewCanhBao" msprop:Generator_TableClassName="viewCanhBaoDataTable" msprop:Generator_TableVarName="tableviewCanhBao" msprop:Generator_TablePropName="viewCanhBao" msprop:Generator_RowDeletingName="viewCanhBaoRowDeleting" msprop:Generator_UserTableName="viewCanhBao" msprop:Generator_RowChangingName="viewCanhBaoRowChanging" msprop:Generator_RowEvHandlerName="viewCanhBaoRowChangeEventHandler" msprop:Generator_RowDeletedName="viewCanhBaoRowDeleted" msprop:Generator_RowEvArgName="viewCanhBaoRowChangeEvent" msprop:Generator_RowChangedName="viewCanhBaoRowChanged" msprop:Generator_RowClassName="viewCanhBaoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TenCanhBao" msprop:Generator_ColumnVarNameInTable="columnTenCanhBao" msprop:Generator_ColumnPropNameInRow="TenCanhBao" msprop:Generator_ColumnPropNameInTable="TenCanhBaoColumn" msprop:Generator_UserColumnName="TenCanhBao">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sort" msprop:Generator_ColumnVarNameInTable="columnsort" msprop:Generator_ColumnPropNameInRow="sort" msprop:Generator_ColumnPropNameInTable="sortColumn" msprop:Generator_UserColumnName="sort" type="xs:int" />
              <xs:element name="OnBoardNumber" msprop:Generator_ColumnVarNameInTable="columnOnBoardNumber" msprop:Generator_ColumnPropNameInRow="OnBoardNumber" msprop:Generator_ColumnPropNameInTable="OnBoardNumberColumn" msprop:Generator_UserColumnName="OnBoardNumber" type="xs:int" minOccurs="0" />
              <xs:element name="OnVactionNumber" msprop:Generator_ColumnVarNameInTable="columnOnVactionNumber" msprop:Generator_ColumnPropNameInRow="OnVactionNumber" msprop:Generator_ColumnPropNameInTable="OnVactionNumberColumn" msprop:Generator_UserColumnName="OnVactionNumber" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="viewSinhNhat" msprop:Generator_TableClassName="viewSinhNhatDataTable" msprop:Generator_TableVarName="tableviewSinhNhat" msprop:Generator_TablePropName="viewSinhNhat" msprop:Generator_RowDeletingName="viewSinhNhatRowDeleting" msprop:Generator_UserTableName="viewSinhNhat" msprop:Generator_RowChangingName="viewSinhNhatRowChanging" msprop:Generator_RowEvHandlerName="viewSinhNhatRowChangeEventHandler" msprop:Generator_RowDeletedName="viewSinhNhatRowDeleted" msprop:Generator_RowEvArgName="viewSinhNhatRowChangeEvent" msprop:Generator_RowChangedName="viewSinhNhatRowChanged" msprop:Generator_RowClassName="viewSinhNhatRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cTenPhong" msprop:Generator_ColumnVarNameInTable="columncTenPhong" msprop:Generator_ColumnPropNameInRow="cTenPhong" msprop:Generator_ColumnPropNameInTable="cTenPhongColumn" msprop:Generator_UserColumnName="cTenPhong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cTenNhanSu" msprop:Generator_ColumnVarNameInTable="columncTenNhanSu" msprop:Generator_ColumnPropNameInRow="cTenNhanSu" msprop:Generator_ColumnPropNameInTable="cTenNhanSuColumn" msprop:Generator_UserColumnName="cTenNhanSu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pAnhDaiDien" msprop:Generator_ColumnVarNameInTable="columnpAnhDaiDien" msprop:Generator_ColumnPropNameInRow="pAnhDaiDien" msprop:Generator_ColumnPropNameInTable="pAnhDaiDienColumn" msprop:Generator_UserColumnName="pAnhDaiDien" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cSoDienThoai" msprop:Generator_ColumnVarNameInTable="columncSoDienThoai" msprop:Generator_ColumnPropNameInRow="cSoDienThoai" msprop:Generator_ColumnPropNameInTable="cSoDienThoaiColumn" msprop:Generator_UserColumnName="cSoDienThoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dNgaySinh" msprop:Generator_ColumnVarNameInTable="columndNgaySinh" msprop:Generator_ColumnPropNameInRow="dNgaySinh" msprop:Generator_ColumnPropNameInTable="dNgaySinhColumn" msprop:Generator_UserColumnName="dNgaySinh" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnBoardVisa" msprop:Generator_TableClassName="OnBoardVisaDataTable" msprop:Generator_TableVarName="tableOnBoardVisa" msprop:Generator_TablePropName="OnBoardVisa" msprop:Generator_RowDeletingName="OnBoardVisaRowDeleting" msprop:Generator_UserTableName="OnBoardVisa" msprop:Generator_RowChangingName="OnBoardVisaRowChanging" msprop:Generator_RowEvHandlerName="OnBoardVisaRowChangeEventHandler" msprop:Generator_RowDeletedName="OnBoardVisaRowDeleted" msprop:Generator_RowEvArgName="OnBoardVisaRowChangeEvent" msprop:Generator_RowChangedName="OnBoardVisaRowChanged" msprop:Generator_RowClassName="OnBoardVisaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nImmigrationId" msprop:Generator_ColumnVarNameInTable="columnnImmigrationId" msprop:Generator_ColumnPropNameInRow="nImmigrationId" msprop:Generator_ColumnPropNameInTable="nImmigrationIdColumn" msprop:Generator_UserColumnName="nImmigrationId" type="xs:int" minOccurs="0" />
              <xs:element name="dDateOfExpiry" msprop:Generator_ColumnVarNameInTable="columndDateOfExpiry" msprop:Generator_ColumnPropNameInRow="dDateOfExpiry" msprop:Generator_ColumnPropNameInTable="dDateOfExpiryColumn" msprop:Generator_UserColumnName="dDateOfExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cDocName" msprop:Generator_ColumnVarNameInTable="columncDocName" msprop:Generator_ColumnPropNameInRow="cDocName" msprop:Generator_ColumnPropNameInTable="cDocNameColumn" msprop:Generator_UserColumnName="cDocName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dayLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndayLeft" msprop:Generator_ColumnPropNameInRow="dayLeft" msprop:Generator_ColumnPropNameInTable="dayLeftColumn" msprop:Generator_UserColumnName="dayLeft" type="xs:int" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnvacationVisa" msprop:Generator_TableClassName="OnvacationVisaDataTable" msprop:Generator_TableVarName="tableOnvacationVisa" msprop:Generator_TablePropName="OnvacationVisa" msprop:Generator_RowDeletingName="OnvacationVisaRowDeleting" msprop:Generator_UserTableName="OnvacationVisa" msprop:Generator_RowChangingName="OnvacationVisaRowChanging" msprop:Generator_RowEvHandlerName="OnvacationVisaRowChangeEventHandler" msprop:Generator_RowDeletedName="OnvacationVisaRowDeleted" msprop:Generator_RowEvArgName="OnvacationVisaRowChangeEvent" msprop:Generator_RowChangedName="OnvacationVisaRowChanged" msprop:Generator_RowClassName="OnvacationVisaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nImmigrationId" msprop:Generator_ColumnVarNameInTable="columnnImmigrationId" msprop:Generator_ColumnPropNameInRow="nImmigrationId" msprop:Generator_ColumnPropNameInTable="nImmigrationIdColumn" msprop:Generator_UserColumnName="nImmigrationId" type="xs:int" minOccurs="0" />
              <xs:element name="dDateOfExpiry" msprop:Generator_ColumnVarNameInTable="columndDateOfExpiry" msprop:Generator_ColumnPropNameInRow="dDateOfExpiry" msprop:Generator_ColumnPropNameInTable="dDateOfExpiryColumn" msprop:Generator_UserColumnName="dDateOfExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cDocName" msprop:Generator_ColumnVarNameInTable="columncDocName" msprop:Generator_ColumnPropNameInRow="cDocName" msprop:Generator_ColumnPropNameInTable="cDocNameColumn" msprop:Generator_UserColumnName="cDocName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dayLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndayLeft" msprop:Generator_ColumnPropNameInRow="dayLeft" msprop:Generator_ColumnPropNameInTable="dayLeftColumn" msprop:Generator_UserColumnName="dayLeft" type="xs:int" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnBoardCertificate" msprop:Generator_TableClassName="OnBoardCertificateDataTable" msprop:Generator_TableVarName="tableOnBoardCertificate" msprop:Generator_TablePropName="OnBoardCertificate" msprop:Generator_RowDeletingName="OnBoardCertificateRowDeleting" msprop:Generator_UserTableName="OnBoardCertificate" msprop:Generator_RowChangingName="OnBoardCertificateRowChanging" msprop:Generator_RowEvHandlerName="OnBoardCertificateRowChangeEventHandler" msprop:Generator_RowDeletedName="OnBoardCertificateRowDeleted" msprop:Generator_RowEvArgName="OnBoardCertificateRowChangeEvent" msprop:Generator_RowChangedName="OnBoardCertificateRowChanged" msprop:Generator_RowClassName="OnBoardCertificateRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nCertificationId" msprop:Generator_ColumnVarNameInTable="columnnCertificationId" msprop:Generator_ColumnPropNameInRow="nCertificationId" msprop:Generator_ColumnPropNameInTable="nCertificationIdColumn" msprop:Generator_UserColumnName="nCertificationId" type="xs:int" minOccurs="0" />
              <xs:element name="dDateOfExpire" msprop:Generator_ColumnVarNameInTable="columndDateOfExpire" msprop:Generator_ColumnPropNameInRow="dDateOfExpire" msprop:Generator_ColumnPropNameInTable="dDateOfExpireColumn" msprop:Generator_UserColumnName="dDateOfExpire" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cCertificationName" msprop:Generator_ColumnVarNameInTable="columncCertificationName" msprop:Generator_ColumnPropNameInRow="cCertificationName" msprop:Generator_ColumnPropNameInTable="cCertificationNameColumn" msprop:Generator_UserColumnName="cCertificationName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dayLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndayLeft" msprop:Generator_ColumnPropNameInRow="dayLeft" msprop:Generator_ColumnPropNameInTable="dayLeftColumn" msprop:Generator_UserColumnName="dayLeft" type="xs:int" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnVacationCertificate" msprop:Generator_TableClassName="OnVacationCertificateDataTable" msprop:Generator_TableVarName="tableOnVacationCertificate" msprop:Generator_TablePropName="OnVacationCertificate" msprop:Generator_RowDeletingName="OnVacationCertificateRowDeleting" msprop:Generator_UserTableName="OnVacationCertificate" msprop:Generator_RowChangingName="OnVacationCertificateRowChanging" msprop:Generator_RowEvHandlerName="OnVacationCertificateRowChangeEventHandler" msprop:Generator_RowDeletedName="OnVacationCertificateRowDeleted" msprop:Generator_RowEvArgName="OnVacationCertificateRowChangeEvent" msprop:Generator_RowChangedName="OnVacationCertificateRowChanged" msprop:Generator_RowClassName="OnVacationCertificateRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nCertificationId" msprop:Generator_ColumnVarNameInTable="columnnCertificationId" msprop:Generator_ColumnPropNameInRow="nCertificationId" msprop:Generator_ColumnPropNameInTable="nCertificationIdColumn" msprop:Generator_UserColumnName="nCertificationId" type="xs:int" minOccurs="0" />
              <xs:element name="dDateOfExpire" msprop:Generator_ColumnVarNameInTable="columndDateOfExpire" msprop:Generator_ColumnPropNameInRow="dDateOfExpire" msprop:Generator_ColumnPropNameInTable="dDateOfExpireColumn" msprop:Generator_UserColumnName="dDateOfExpire" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cCertificationName" msprop:Generator_ColumnVarNameInTable="columncCertificationName" msprop:Generator_ColumnPropNameInRow="cCertificationName" msprop:Generator_ColumnPropNameInTable="cCertificationNameColumn" msprop:Generator_UserColumnName="cCertificationName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dayLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndayLeft" msprop:Generator_ColumnPropNameInRow="dayLeft" msprop:Generator_ColumnPropNameInTable="dayLeftColumn" msprop:Generator_UserColumnName="dayLeft" type="xs:int" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnBoardContract" msprop:Generator_TableClassName="OnBoardContractDataTable" msprop:Generator_TableVarName="tableOnBoardContract" msprop:Generator_TablePropName="OnBoardContract" msprop:Generator_RowDeletingName="OnBoardContractRowDeleting" msprop:Generator_UserTableName="OnBoardContract" msprop:Generator_RowChangingName="OnBoardContractRowChanging" msprop:Generator_RowEvHandlerName="OnBoardContractRowChangeEventHandler" msprop:Generator_RowDeletedName="OnBoardContractRowDeleted" msprop:Generator_RowEvArgName="OnBoardContractRowChangeEvent" msprop:Generator_RowChangedName="OnBoardContractRowChanged" msprop:Generator_RowClassName="OnBoardContractRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ngày_x0020_hết_x0020_hạn" msprop:Generator_ColumnVarNameInTable="columnNgày_hết_hạn" msprop:Generator_ColumnPropNameInRow="Ngày_hết_hạn" msprop:Generator_ColumnPropNameInTable="Ngày_hết_hạnColumn" msprop:Generator_UserColumnName="Ngày hết hạn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Thời_x0020_hạn" msprop:Generator_ColumnVarNameInTable="columnThời_hạn" msprop:Generator_ColumnPropNameInRow="Thời_hạn" msprop:Generator_ColumnPropNameInTable="Thời_hạnColumn" msprop:Generator_UserColumnName="Thời hạn" type="xs:short" minOccurs="0" />
              <xs:element name="Ngày_x0020_ký" msprop:Generator_ColumnVarNameInTable="columnNgày_ký" msprop:Generator_ColumnPropNameInRow="Ngày_ký" msprop:Generator_ColumnPropNameInTable="Ngày_kýColumn" msprop:Generator_UserColumnName="Ngày ký" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Số_x0020_HĐLĐ" msprop:Generator_ColumnVarNameInTable="columnSố_HĐLĐ" msprop:Generator_ColumnPropNameInRow="Số_HĐLĐ" msprop:Generator_ColumnPropNameInTable="Số_HĐLĐColumn" msprop:Generator_UserColumnName="Số HĐLĐ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tên_x0020_loại_x0020_hợp_x0020_đồng" msprop:Generator_ColumnVarNameInTable="columnTên_loại_hợp_đồng" msprop:Generator_ColumnPropNameInRow="Tên_loại_hợp_đồng" msprop:Generator_ColumnPropNameInTable="Tên_loại_hợp_đồngColumn" msprop:Generator_UserColumnName="Tên loại hợp đồng" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OnVacationContract" msprop:Generator_TableClassName="OnVacationContractDataTable" msprop:Generator_TableVarName="tableOnVacationContract" msprop:Generator_TablePropName="OnVacationContract" msprop:Generator_RowDeletingName="OnVacationContractRowDeleting" msprop:Generator_UserTableName="OnVacationContract" msprop:Generator_RowChangingName="OnVacationContractRowChanging" msprop:Generator_RowEvHandlerName="OnVacationContractRowChangeEventHandler" msprop:Generator_RowDeletedName="OnVacationContractRowDeleted" msprop:Generator_RowEvArgName="OnVacationContractRowChangeEvent" msprop:Generator_RowChangedName="OnVacationContractRowChanged" msprop:Generator_RowClassName="OnVacationContractRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ngày_x0020_hết_x0020_hạn" msprop:Generator_ColumnVarNameInTable="columnNgày_hết_hạn" msprop:Generator_ColumnPropNameInRow="Ngày_hết_hạn" msprop:Generator_ColumnPropNameInTable="Ngày_hết_hạnColumn" msprop:Generator_UserColumnName="Ngày hết hạn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Thời_x0020_hạn" msprop:Generator_ColumnVarNameInTable="columnThời_hạn" msprop:Generator_ColumnPropNameInRow="Thời_hạn" msprop:Generator_ColumnPropNameInTable="Thời_hạnColumn" msprop:Generator_UserColumnName="Thời hạn" type="xs:short" minOccurs="0" />
              <xs:element name="Ngày_x0020_ký" msprop:Generator_ColumnVarNameInTable="columnNgày_ký" msprop:Generator_ColumnPropNameInRow="Ngày_ký" msprop:Generator_ColumnPropNameInTable="Ngày_kýColumn" msprop:Generator_UserColumnName="Ngày ký" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Số_x0020_HĐLĐ" msprop:Generator_ColumnVarNameInTable="columnSố_HĐLĐ" msprop:Generator_ColumnPropNameInRow="Số_HĐLĐ" msprop:Generator_ColumnPropNameInTable="Số_HĐLĐColumn" msprop:Generator_UserColumnName="Số HĐLĐ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tên_x0020_loại_x0020_hợp_x0020_đồng" msprop:Generator_ColumnVarNameInTable="columnTên_loại_hợp_đồng" msprop:Generator_ColumnPropNameInRow="Tên_loại_hợp_đồng" msprop:Generator_ColumnPropNameInTable="Tên_loại_hợp_đồngColumn" msprop:Generator_UserColumnName="Tên loại hợp đồng" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="monthLeft" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmonthLeft" msprop:Generator_ColumnPropNameInRow="monthLeft" msprop:Generator_ColumnPropNameInTable="monthLeftColumn" msprop:Generator_UserColumnName="monthLeft" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>